SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}Haan{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}Haan{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}' OR prCountry = 'Haan') AND (prLocation LIKE '{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}Germany{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}Germany{d3e500051fb2810f08382f5ec77a00f315027e8d8e8612065b07c2a00509c6ac}' OR prCountry = 'Germany')